Editing csv is fast and straightforward using DocHub. Skip downloading software to your laptop or computer and make alterations using our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its convenience and robust features that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and send records for completion to other people. All of this, put together with a competitive price, makes DocHub the ideal option to blot TIN in csv files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the safety of your data, as we securely store them in the DocHub cloud.
hello and welcome in this short video weamp;#39;re going to combine 120 CSV files before we get started letamp;#39;s just quickly take a look at the folder every year for the past 10 years weamp;#39;ve exported one CSV file per month that contains all the transactions from our accounting system so there we have 12 files in the 2017 folder 12 files of the 2016 folder and so on now we need to combine them we need to combine all this historical data into a single excel file what are we supposed to do open each copy and paste we could that would be the slow way letamp;#39;s see if we can use a get transform query to do it the fast way data new query from file from folder at this point we could type or paste or browse to select the folder that contains the documents that weamp;#39;re interested in we click OK and Excel gives us a little preview which lists all the files that are in those folders and any subfolders it traverses that whole directory ok at this point we click combine and