Importing notepad data to excel difficult split

0 votes

I want to transfer this data from notepad to excel and split it into columns but the problem is that the data (i didn't make this) doesnt split on a delimiter. All the data looks like variations of the following this

Header: "a" "b" "c" "d" "e" ... "n"
rows:   "1" "sgvgs-dvfds" "" "0.0" "d'/.d" ... "m"

Everything is contained within quotations. Does anyone know in excel on how to make it happen or even through powershell?

Mar 10, 2022 in Database by Edureka
• 13,640 points
104 views

1 answer to this question.

0 votes
Excel: How to Use It

On the Data tab, go to "From Text/CSV."
Open the file by selecting it and double-clicking it.
Set the delimiter to Space in the resulting window, then click Load Bingo to load the OP's Excel data (and it handles empty columns properly)
answered Mar 14, 2022 by gaurav
• 22,940 points

Related Questions In Database

0 votes
1 answer

Easy way to export multiple data.frame to multiple Excel worksheets

To export numerous data frames from R ...READ MORE

answered Mar 25, 2022 in Database by gaurav
• 22,940 points
756 views
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

Tally Data in Excel or PDF: How ...READ MORE

answered Mar 30, 2022 in Database by gaurav
• 22,940 points
339 views
0 votes
0 answers

How to split a string of text in excel based on a given word?

I have a list of combinations of ...READ MORE

Apr 4, 2022 in Database by gaurav
• 22,940 points
94 views
0 votes
1 answer

Excel data to table on Dashing Dashboard?

It contains a feature named "Download." The ...READ MORE

answered Apr 11, 2022 in Database by gaurav
• 22,940 points
213 views
0 votes
0 answers

Export SQL query data to Excel

My query returns a huge amount of ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
• 27,740 points
105 views
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,830 points
1,132 views
+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

answered Jan 4, 2019 in Database by Priyaj
• 58,100 points
655 views
0 votes
1 answer

What is the best way to fetch data from table?

Hey Shraddha, I understand your doubts about fetching ...READ MORE

answered May 25, 2019 in Database by sampriti
• 1,120 points
1,179 views
0 votes
1 answer
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

Open data (Ledger/P&L or Balance Sheet) that ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 22,940 points
763 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP