Ledgy lets you export all your data as CSV files. You might be thinking “Well great, but I hate all the formatting problems when opening CSV in Excel or Google Sheets”. Don’t worry we’ve thought about this and here’s a step-by-step guide to import CSV with all special characters and numbers well-formatted.
To open your CSV file optimally in Microsoft Excel or Google Sheets you need to make sure that
Datamenu click on
Delimited — Characters such as commas or tabs separate each field. Click on next.
Advanced…and set decimal separator to dot
.and thousands separator to a comma
Import. Choose the Upload tab and upload your CSV file.
Import dataand you’re done.
With a score of 4 against 7 setup steps, Google does a better job than Microsoft to import CSV files 😃