Windows 10: Export file format / file

Discus and support Export file format / file in Windows 10 Network and Sharing to solve the problem; I am exporting financial data from a bank web site. The default file is .CSV - which changes the numbers to text. How do I change the default to... Discussion in 'Windows 10 Network and Sharing' started by Jeff 14723, Dec 3, 2019 at 8:33 AM.

  1. Export file format / file


    I am exporting financial data from a bank web site. The default file is .CSV - which changes the numbers to text. How do I change the default to .XLSX so that the number format is retained in the export file?

    :)
     
  2. newtekie1 Win User

    Outlook PST File Problem

    That is exactly what I was going to suggest. Export everything to another PST file, delete the old(or rather move it out of the default folder) and replace it with the new PST file that you exported.
     
  3. ddelo Win User
    Export All Administrative Events to Excel


    To analyze events, from the Windows Event Viewer, there is a simple way to export all Administrative Events to Excel, with PowerShell.

    Exporting all Administrative Events to Excel is a simple two Step process, as described here:

    Step 1 - Create the Administrative Events View .xml file
    1. Open Eventviewer (%windir%\system32\eventvwr.msc)
    2. Navigate to: Event Viewer (Local) > Custom Views > Administrative Events
    3. In the “Actions” pane select “Filter Current Custom View”.
    4. Select the the XML tab.
    5. Press Ctrl+A to select all the XML code of the Custom View.
    6. Open a notepad, paste the selected code and save the file to your Desktop as AdmEvtView.xml


    Step 2 - Create the csv file with the events
    1. Download the ExportEvtCSV.zip file, which contains the script ExportEvtCSV.ps1 and unzip it, on your Desktop.
      It's not a fancy script, just basic PowerShell commands to create a csv file on the Desktop.
    2. In Windows Search, type “ISE” (without the quotes) to open “Windows PowerShell ISE” and Run as administrator
    3. To allow running the script, change the ExecutionPolicy, for this session. To do that, in the Console pane type:
      Code:
      Code:
      Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass -force
    4. In the Windows PowerShell ISE, open and run the script: ExportEvtCSV.ps1
      The script will create a csv file with a name YYYYMMDD.HHMM.csv on the Desktop
    5. When done, open the newly created .csv file, format the columns as needed and optionally save it as .xlsx, if you wish.
    That’s it! You now have all the Administrative Events in Excel for filtering and further analysis. Export file format / file :)

    Now to the more technical hard stuff... *Confused

    There is a reason for running the script from within PowerShell ISE!

    It would be great if everything was also working perfectly, when running the script from an elevated PowerShell too.

    We can run it from an elevated PowerShell, which means that you just follow the Step 1, as above but for the Step 2 instead of the ISE you run the script from an elevated PowerShell.

    The problem is that it will work only for anybody who has en-US format for the dates. Everyone else, who has another format (i.e. en-GB, fr-FR, el-GR etc.), the dates are not translated properly by Excel (although the script uses the –UseCulture switch) and remain as text in the en-US format.

    I'm not sure if this a bug of the "export-csv" cmdlet, but although it runs the way it supposed to from within the ISE, from PowerShell there is a problem with the dates format.
    As I haven’t found a way to overcome this obstacle, any suggestion from the PowerShell gurus of the forum (like my good friend Shawn @Brink, for instance), is welcome.
     
  4. Export file format / file

    Error Exporting windows contact to vcf file

    Hi Kamesh,

    I first imported the names and mobile numbers from a CSV file by following the below steps.

    1. Search--> Contacts--> Import --> Choose the CSV file; this will convert the CSV file to windows contact format.

    2. Contacts-->export--> VCF --> will convert the windows contact to VCF file. This step gives an error message "Error Exporting contacts".
     
    rogerjoseph95, Dec 3, 2019 at 8:34 AM
    #4
Thema:

Export file format / file

Loading...
  1. Export file format / file - Similar Threads - Export file format

  2. format files

    in Windows 10 Customization
    format files: I recorded church service this past Sunday with my video camera. I tried to edit it with windows 10 it's saying something about the format of the file. what do I need to do ? I used it earlier and the computer began to update right in the middle of it savivng...
  3. Exporting .3MF file with textures

    in Windows 10 Software and Apps
    Exporting .3MF file with textures: Hi, I am trying to export a .3mf file that has textures that I applied in 3D Builder. However when I open the exported file in another program (eg. 3D Viewer or Paint 3D) the textured surfaces are just gray??? Surfaces with plain colors show up fine. Thanks...
  4. File explorer format

    in Windows 10 Network and Sharing
    File explorer format: After the recent 1903 update I had noticed that the downloads folder in file explorer had a weird format to it. It was organized by "friendly date". is there any way to revert to the original layout prior to 1903? [ATTACH]...
  5. File format.

    in Windows 10 Network and Sharing
    File format.: How do I change a music file format from wpl to wav or mp3? https://answers.microsoft.com/en-us/windows/forum/all/file-format/3a33e1dd-d802-4fe4-bd18-2f45a8a89b3a"
  6. File format

    in Windows 10 Network and Sharing
    File format: How do I change a photo file format. Photos were taken with a Cannon EOS Rebel T1i. Thank you https://answers.microsoft.com/en-us/windows/forum/all/file-format/aceb5f6b-db57-4d98-ad4f-0155736f852f"
  7. File Format Change

    in Windows 10 Software and Apps
    File Format Change: Hi, My all File format suddenly change with "Assignments1.xlsx.DATAWAIT" DATAWAIT Format, how I can resolve this issue. Thanks https://answers.microsoft.com/en-us/windows/forum/all/file-format-change/5837546c-3714-4139-9b55-7b5c565aea1d
  8. Gmail File > Import/Export > Export to file > Browse to desired place

    in Windows 10 Support
    Gmail File > Import/Export > Export to file > Browse to desired place: Is there a Gmail forum 120054
  9. changing file format

    in Windows 10 Software and Apps
    changing file format: how do you change txt file to pdf? https://answers.microsoft.com/en-us/windows/forum/apps_windows_10-winapps-appscat_tools/changing-file-format/fb57ff45-456a-4307-bb4e-1e8d1c1eb605
  10. Can't find exported pdf files

    in Windows 10 Software and Apps
    Can't find exported pdf files: [img] I'm Using Open Office which has the option to export files in PDF format, but when I do this, I can't find the file. It's not in documents, downloads or pictures. I can see it as it's being saved but can't find it afterwards if this makes any sense. I hope this snip...