Great that you went to the extra step of changing formatting from general to text. This is particularly important when importing csv files containing numeric information - which you don't need to do any math on, eg: - telephone numbers that start with a leading zeros, and you don't want Excell to drop the leading zeros or turn it into scientific number format such as 4.32E+08, and - times in hh:mm:ss format and you just want to see it as text and not have Excel interpret the information and only display hh:mm, and - dates and don't want to trust excel to recognise which of the numerous date formats has been used. (Life will be bliss if everyone just used ISO8601, but oh well)
learned to change csv to excel worksheet, my problem is QB it self create csv instead to excel work sheet, any idea what I should do in QuickBooks in order to Create new worksheet in Excel not in csv file, am using window 10, 2020 QB but my excel is 2007. Thanks
What if the data has commas and your delimiter is also comma ie: addresses or company names, and the file has text qualifiers of quotation marks on some columns and some do not have quotations? Driving me crazy.
@@aksonai Thank you. I ended up using C# to first convert the file to xlsx, then import it; using Etl to clean up data. It worked perfectly. Inside a for each loop got over 200 files processed, and continues to do so.
Thanks for so easily explaining this. I searched several pages that made this much more complicated than it needed to be.
Great that you went to the extra step of changing formatting from general to text.
This is particularly important when importing csv files containing numeric information - which you don't need to do any math on, eg:
- telephone numbers that start with a leading zeros, and you don't want Excell to drop the leading zeros or turn it into scientific number format such as 4.32E+08, and
- times in hh:mm:ss format and you just want to see it as text and not have Excel interpret the information and only display hh:mm, and
- dates and don't want to trust excel to recognise which of the numerous date formats has been used. (Life will be bliss if everyone just used ISO8601, but oh well)
Thank You , I had try to figure this all day till i found this video, thank you so much.
You are the best ,Tom!
Great and very clear, tnx
Thanks, could not have done it without your video!
+Gerjola Joan Voortman I'm glad to hear it was helpful. 😀
Solved my problem in a mojo! thank you for making it short and simple!
I am glad you found it helpful! :)
Thanks for saving me so much time and effort!!!
Awesome job!
Wow thank you verymuch
You save my day!
You are the best. Solved our problem!
I'm glad it was helpful to you. This comment made my day 😊
Well done. Thanks for sharing it :)
Thank you so much
Thank-you this was just what I needed ;-))
Thank you very much, very useful!
Glad, you found it helpful!
Love u bro
learned to change csv to excel worksheet, my problem is QB it self create csv instead to excel work sheet, any idea what I should do in QuickBooks in order to Create new worksheet in Excel not in csv file, am using window 10, 2020 QB but my excel is 2007. Thanks
Thank you!
Why by importing the processed csv file back into ERP software - all my data end up in one cell?
Thank you
What if the data has commas and your delimiter is also comma ie: addresses or company names, and the file has text qualifiers of quotation marks on some columns and some do not have quotations? Driving me crazy.
Hi, the only solution for data with commas is to wrap it with quotes, so it doesn't break CSV formatting. Good luck!
@@aksonai Thank you.
I ended up using C# to first convert the file to xlsx, then import it; using Etl to clean up data. It worked perfectly. Inside a for each loop got over 200 files processed, and continues to do so.
thank you thank you thank you
SONGÜL GÜRBÜZ You're welcome!
tried it but my upc codes goes back to scientific format
Sick
If you want to go to the real solution go directly to the 1:07. You can gain 1 minute more of your life time..
Still, nice explanation.
U R right:)
I have some issue can you pls help me.
The problem I have is importing the csv with paragraph text containing line breaks.
2016 Excel?
All different on Microsoft excel in 365. The delimiter options don't come up.
Yes you are right! There was an update in Microsoft Excel, I will also try to make another, updated tutorial in the near future. Thanks for watching!
Thank you so much 🔥🔥🔥🔥🔥